MFG RedShift Machine Data System API - Implementation Template
Data mappings
This document provides information generated from the DataWeave scripts included in the project, such as function definitions, variable definitions, and data mapping tables.
| Module | Description |
|---|---|
| createMachineDataRequest | |
| getMachineDataResponse |
createMachineDataRequest
Source:
./src/main/resources/dwl/createMachineDataRequest.dwl
Mapping Tables
Redshift Machine Data Create request mapping.
| Redshift Field | Create machine data CIM Request | Description |
|---|---|---|
| Machine_Id | machineId | machine Id details |
| Maintenance_Reason | reason | reason for maintenance |
| Created_By | auditInfo.createdBy | created by details |
| Updated_By | auditInfo.updatedBy | updated by details |
| Location | location | name of the location |
| Source | source | source of the machine data |
| Temperature | temperature | temperature of the device |
| Temp_Degree | tempUnit | units of the temperature |
| Oil_Level | oilLevel | level of the oil in numbers |
| Oil_Unit | oilUnit | unit of the oil |
| Noise_Level | noiseLevel | level of the noise in numbers |
| Noise_Unit | noiseUnit | unit of the noise |
| Vibration_Delta | vibrationDelta | value of the vibration in numbers |
| Vibration_Unit | vibrationUnit | units of the vibration |
| Comments | comments | comments on the machine data |
| Maintenance_Status | maintenanceStatus | status of the maintenance |
getMachineDataResponse
Source:
./src/main/resources/dwl/getMachineDataResponse.dwl
Mapping Tables
Get Redshift Machine Data Response mapping.
| CIM Field | machine data response field | Description |
|---|---|---|
| machineId | Machine_Id | machine Id details |
| name | Machine_Id | machine Id details |
| temperature | temperature | temperature of the device |
| tempUnit | temp_degree | units of the temperature |
| oilLevel | oil_level | level of the oil in numbers |
| oilUnit | oil_unit | unit of the oil |
| noiseLevel | noise_level | level of the noise in numbers |
| noiseUnit | noise_unit | unit of the noise |
| vibrationDelta | vibration_delta | value of the vibration in numbers |
| vibrationUnit | vibration_unit | units of the vibration |
| reason | Maintenance_Reason | reason for maintenance |
| auditInfo.createdBy | CreatedById | CreatedBy Id |
| auditInfo.updatedBy | LastModifiedById | UpdatedBy Id |
| auditInfo.updatedDate | LastModifiedDate | Updated Date |
| auditInfo.createdDate | CreatedDate | Created Date |
| Location | Location | name of the location |
| source | source | source of the machine data |
| comments | comments | comments on the machine data |
| maintenanceStatus | maintenance_status | status of the maintenance |